If you want to send multiple records to an oracle function, a common practice is to create the function with one or more parameters as a table of an object type. In the function itself, you can loop thru the array or select from it using to TABLE command. Another option to send an array … Continue reading Run a function with a table of User Defined Type (UDT) as a parameter using SQLPlus